MetObjects

Data license: CC0 · Data source: metmuseum/openaccess

5 rows where Artist Nationality = 842

Search:

descending

Link	rowid ▼	Object Number	Is Public Domain	Object ID	Department	Object Name	Title	Artist Role	Artist Prefix	Artist Display Name	Artist Display Bio	Artist Alpha Sort	Artist Nationality	Artist Begin Date	Artist End Date	Object Date	Object Begin Date	Object End Date	Medium	Dimensions	Credit Line	Classification	Link Resource	Metadata Date	Repository
207967	207967	53.685.49	0	335325	Drawings and Prints 11	Drawing 23	Landscape	Artist 2		W. E. Cyrenius	Austrian (?), 20th century	Cyrenius, W. E. 18032	Austrian? 842	1900	1960	1925	1925	1925	Watercolor and gouache. 29801	7 1/16 x 9 3/8 in. (17.9 x 23.8 cm)	Gift of Eugene L. Garbaty, 1953	Drawings 9	http://www.metmuseum.org/art/collection/search/335325	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
207968	207968	53.685.23	0	335326	Drawings and Prints 11	Drawing 23	Mondnacht auf der Brombergshoehe	Artist 2		W. E. Cyrenius	Austrian (?), 20th century	Cyrenius, W. E. 18032	Austrian? 842	1900	1960	1928	1928	1928	Pen and black ink, heightened with white bodycolor; framing line in pen and black ink 29802	9 1/2 x 7 15/16 in. (24.2 x 20.2 cm)	Gift of Eugene L. Garbaty, 1953	Drawings 9	http://www.metmuseum.org/art/collection/search/335326	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
207984	207984	47.100.1175	1	335342	Drawings and Prints 11	Drawing 23	Garden Pavillion	Artist 2		E. Ender	Austrian (?)	Ender, E. 18038	Austrian? 842			1812	1812	1812	Brush and brownish-grey wash over graphite. 29816	10 7/8 x 14 3/8 in. (27.6 x 36.5 cm)	Harris Brisbane Dick Fund, 1947	Drawings 9	http://www.metmuseum.org/art/collection/search/335342	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
253284	253284	53.685.48	0	381812	Drawings and Prints 11	Drawing 23	Goetheweg bei Torfhaus-Brocken	Artist 2		W. E. Cyrenius	Austrian (?), 20th century	Cyrenius, W. E. 18032	Austrian? 842	1900	1960	1921	1921	1921	bodycolor and watercolor 40535	5 9/16 x 8 1/4 in. (14.1 x 21 cm)	Gift of Eugene L. Garbaty, 1953	Drawings 9	http://www.metmuseum.org/art/collection/search/381812	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1
260489	260489	WW.153	0	389207	Drawings and Prints 11	Print 731	Happy Easter! (Frohe Ostern!)	Publisher\|Artist 740	Published by	Wiener Werkstätte\|Valerie Petter	Austrian (?), active early 20th century	Wiener Werkstätte\|Petter, Valerie 37822	Austrian? 842	0020	0020	1908	1908	1908	Color lithograph 30750	sheet: 5 1/2 x 3 7/16 in. (14 x 8.7 cm)	Museum Accession, transferred from the Library	Prints 13	http://www.metmuseum.org/art/collection/search/389207	4/23/2018 8:00:01 AM	Metropolitan Museum of Art, New York, NY 1

Advanced export

JSON shape: default, array, newline-delimited

CREATE TABLE "MetObjects" (
"Object Number" TEXT,
  "Is Highlight" INTEGER,
  "Is Public Domain" INTEGER,
  "Object ID" INTEGER,
  "Department" INTEGER,
  "Object Name" INTEGER,
  "Title" TEXT,
  "Culture" INTEGER,
  "Period" REAL,
  "Dynasty" INTEGER,
  "Reign" INTEGER,
  "Portfolio" INTEGER,
  "Artist Role" INTEGER,
  "Artist Prefix" REAL,
  "Artist Display Name" TEXT,
  "Artist Display Bio" TEXT,
  "Artist Suffix" REAL,
  "Artist Alpha Sort" INTEGER,
  "Artist Nationality" INTEGER,
  "Artist Begin Date" TEXT,
  "Artist End Date" TEXT,
  "Object Date" TEXT,
  "Object Begin Date" INTEGER,
  "Object End Date" INTEGER,
  "Medium" INTEGER,
  "Dimensions" TEXT,
  "Credit Line" TEXT,
  "Geography Type" INTEGER,
  "City" INTEGER,
  "State" INTEGER,
  "County" INTEGER,
  "Country" INTEGER,
  "Region" INTEGER,
  "Subregion" INTEGER,
  "Locale" INTEGER,
  "Locus" INTEGER,
  "Excavation" INTEGER,
  "River" INTEGER,
  "Classification" INTEGER,
  "Rights and Reproduction" REAL,
  "Link Resource" TEXT,
  "Metadata Date" TEXT,
  "Repository" INTEGER
,
FOREIGN KEY ("Department") REFERENCES [Department](id),
    FOREIGN KEY ("Object Name") REFERENCES [Object Name](id),
    FOREIGN KEY ("Culture") REFERENCES [Culture](id),
    FOREIGN KEY ("Dynasty") REFERENCES [Dynasty](id),
    FOREIGN KEY ("Reign") REFERENCES [Reign](id),
    FOREIGN KEY ("Portfolio") REFERENCES [Portfolio](id),
    FOREIGN KEY ("Artist Role") REFERENCES [Artist Role](id),
    FOREIGN KEY ("Artist Alpha Sort") REFERENCES [Artist Alpha Sort](id),
    FOREIGN KEY ("Artist Nationality") REFERENCES [Artist Nationality](id),
    FOREIGN KEY ("Medium") REFERENCES [Medium](id),
    FOREIGN KEY ("Geography Type") REFERENCES [Geography Type](id),
    FOREIGN KEY ("City") REFERENCES [City](id),
    FOREIGN KEY ("State") REFERENCES [State](id),
    FOREIGN KEY ("County") REFERENCES [County](id),
    FOREIGN KEY ("Country") REFERENCES [Country](id),
    FOREIGN KEY ("Region") REFERENCES [Region](id),
    FOREIGN KEY ("Subregion") REFERENCES [Subregion](id),
    FOREIGN KEY ("Locale") REFERENCES [Locale](id),
    FOREIGN KEY ("Locus") REFERENCES [Locus](id),
    FOREIGN KEY ("Excavation") REFERENCES [Excavation](id),
    FOREIGN KEY ("River") REFERENCES [River](id),
    FOREIGN KEY ("Classification") REFERENCES [Classification](id),
    FOREIGN KEY ("Repository") REFERENCES [Repository](id));
CREATE INDEX ["MetObjects_Department"] ON [MetObjects]("Department");
CREATE INDEX ["MetObjects_Object Name"] ON [MetObjects]("Object Name");
CREATE INDEX ["MetObjects_Culture"] ON [MetObjects]("Culture");
CREATE INDEX ["MetObjects_Dynasty"] ON [MetObjects]("Dynasty");
CREATE INDEX ["MetObjects_Reign"] ON [MetObjects]("Reign");
CREATE INDEX ["MetObjects_Portfolio"] ON [MetObjects]("Portfolio");
CREATE INDEX ["MetObjects_Artist Role"] ON [MetObjects]("Artist Role");
CREATE INDEX ["MetObjects_Artist Alpha Sort"] ON [MetObjects]("Artist Alpha Sort");
CREATE INDEX ["MetObjects_Artist Nationality"] ON [MetObjects]("Artist Nationality");
CREATE INDEX ["MetObjects_Medium"] ON [MetObjects]("Medium");
CREATE INDEX ["MetObjects_Geography Type"] ON [MetObjects]("Geography Type");
CREATE INDEX ["MetObjects_City"] ON [MetObjects]("City");
CREATE INDEX ["MetObjects_State"] ON [MetObjects]("State");
CREATE INDEX ["MetObjects_County"] ON [MetObjects]("County");
CREATE INDEX ["MetObjects_Country"] ON [MetObjects]("Country");
CREATE INDEX ["MetObjects_Region"] ON [MetObjects]("Region");
CREATE INDEX ["MetObjects_Subregion"] ON [MetObjects]("Subregion");
CREATE INDEX ["MetObjects_Locale"] ON [MetObjects]("Locale");
CREATE INDEX ["MetObjects_Locus"] ON [MetObjects]("Locus");
CREATE INDEX ["MetObjects_Excavation"] ON [MetObjects]("Excavation");
CREATE INDEX ["MetObjects_River"] ON [MetObjects]("River");
CREATE INDEX ["MetObjects_Classification"] ON [MetObjects]("Classification");
CREATE INDEX ["MetObjects_Repository"] ON [MetObjects]("Repository");
CREATE INDEX metobjects_IsHighlight ON MetObjects("Is Highlight");
CREATE INDEX metobjects_IsPublicDomain ON MetObjects("Is Public Domain");
CREATE INDEX metobjects_Department ON MetObjects("Department");
CREATE INDEX metobjects_Culture ON MetObjects("Culture");
CREATE INDEX metobjects_Period ON MetObjects("Period");
CREATE INDEX metobjects_Dynasty ON MetObjects("Dynasty");
CREATE INDEX metobjects_Medium ON MetObjects("Medium");
CREATE INDEX metobjects_City ON MetObjects("City");
CREATE INDEX metobjects_State ON MetObjects("State");
CREATE INDEX metobjects_County ON MetObjects("County");
CREATE INDEX metobjects_Country ON MetObjects("Country");
CREATE INDEX metobjects_Region ON MetObjects("Region");
CREATE INDEX metobjects_Subregion ON MetObjects("Subregion");
CREATE INDEX metobjects_Locale ON MetObjects("Locale");
CREATE INDEX metobjects_Locus ON MetObjects("Locus");
CREATE INDEX metobjects_Excavation ON MetObjects("Excavation");
CREATE INDEX metobjects_River ON MetObjects("River");